select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Coral Red Ball Gown Strapless Appliques Sweet Sixteen Dresses
Sweetheart Floor-length Appliques Teal Ball Gown Quinces Dresses
Pink Ball Gown Strapless Appliques Sweet Sixteen Quinceanera Dresses
Ball Gown Dresses For 15 Sweetheart Ruffles in Apple Green
Purple Ball Gown Sweetheart Appliques Dresses For a Quince
Blue Sweetheart Beading and Appliques Organza Quinceanera Gowns
Green Ball and Black Appliques Sweet Sixteen Dresses Made in Tulle
Hot Pink Quinceanera Dress Hand Made Flowers With Embroidery
Appliques Layered Ruffles Colorful Dresses 15 Wear For Graduation
Long Sleeves and Appliques Decorated Quinceanera Dress in Fushsia
Apron Front Baby Blue Ball Gown Beading and Appliques Dresses 15
Halter Top Ball Gown White Sweet Sixteen Dresses for Sale with Beading
Halter Top and Pick-ups Quinceanera Dress with Beading Embroidery
Tulle Overlay Dress For Quinceaneras with Appliques Paillette Skirt
Matching Jacket and Ruffles for Appliques Dresses 15 with Lace up
Hand Made Flowers Decorate Waist For Ruched Quinceanera Dress
Yellow Pleating Ball Gown with Heavy Tulle Appliques Dresses 15
Aqua Blue Ball Gown 2013 Dresses For a Quince with Black Appliques
White Ball Gown and Purple Embroidery 2013 Sweet Sixteen Dresses
Multi-color Ball Gown Appliques with Beading Dresses For a Quince
Aqua Blue Strapless Fabric With Rolling Flowers Quinceanera Dress
Pretty White Ball Gown Dresses of 15 with Ruffles and Appliques
Plus Size Ball Gown Pick-ups Beaded Baby Blue Sweet 16 Dresses
New Arrival Lace-Up Ball Gown Appliqued Lavender Sweet 15 Dresses
Ball Gown Sweetheart Appliqued Ruched Orange Quince Dresses
Perfect Ball Gown Appliqued Spring Green Quinceanera Party Dresses
Beautiful Ball Gown Appliqued Ruched Orange Sweet 16 Dresses
Impressive Rose Pink Appliqued Beaded Quinceanera Gown Online
New Style Taffeta Ball Gown Beaded Green Sweet Sixteen Dresses
Embroidery Hot Pink Ball Gown Sweetheart Quinceanera Dresses